package cn.bdqn.hospital.dao;

import cn.bdqn.hospital.entity.OrderAll;

import java.sql.SQLException;
import java.util.List;

/**
 * 订单总表dao层接口
 */
public interface OrderAllDao {

    /**
     * 新增订单总表
     * @param orderAll
     * @return
     * @throws SQLException
     */
    public int add(OrderAll orderAll) throws SQLException;

    /**
     * 修改订单总表
     * @return
     * @throws SQLException
     */
    public int update() throws SQLException;

    /**
     * 通过订单id删除订单
     * @param ddId
     * @return
     * @throws SQLException
     */
    public int delete(Integer ddId) throws SQLException;

    /**
     * 分页查询所有订单总单
     * @return
     * @throws SQLException
     */
    public List<OrderAll> getAll(Integer pageNo,Integer pageSize)throws SQLException;

    /**
     * 通过患者id分页查询订单总表
     * @return
     * @throws SQLException
     */
    public List<OrderAll> getOrderAllByHzId(Integer haId,Integer pageNo,Integer pageSize)throws SQLException;

    /**
     * 通过医生id查询订单总表
     * @param yhId
     * @param pageNo
     * @param pageSize
     * @return
     * @throws SQLException
     */
    public List<OrderAll> getOrderAllByYgId(Integer yhId,Integer pageNo,Integer pageSize)throws SQLException;

    /**
     * 通过id查询订单
     * @param ddzId
     * @return
     * @throws SQLException
     */
    public OrderAll getOrderAllInfoByNid(Integer ddzId)throws SQLException;

}
